Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Previous Table of Contents Next


Oracle Tools

In addition to its database design tools, Oracle has several development tools to offer. Oracle’s Power Objects is similar to the third-party tools described later in this chapter. Power Objects is a graphical “drag-and-drop” tool that includes a small database called BLAZE. You can use this small standalone RDBMS to assist in the development of applications and also for small standalone applications. Power Objects’ real power comes when you use it as an application development tool. Power Objects is currently available on the Windows and Macintosh platforms.

Oracle also offers the traditional Cooperative Development Environment (CDE) tools that have evolved into the Oracle Developer/2000 development tools. These tools have been in production for quite some time on almost all the platforms Oracle supports. Developer/2000 added flexibility that allows you to develop applications across a variety of platforms using the same base code set. The Oracle Developer/2000 tools are described in detail in Chapter 35, “Using GUI Builders,” along with how to tune the applications developed by these tools.

Oracle Power Objects

Oracle Power Objects is a standalone, object-oriented development tool you can use to develop client/server applications or standalone applications by using the small BLAZE database provided with it. Oracle Power Objects allows you to drag-and-drop everything. In this manner, you can quickly develop and test small applications. Although Power Objects is great for developing small standalone applications, its real power comes from its use as an application development tool. Power Objects is currently available for Windows and Macintosh.

Oracle Developer/2000

Oracle Developer/2000 is a higher-end tool than Power Objects. Oracle Developer/2000 tools are the follow-on to the traditional CDE tools offered by Oracle. The Developer/2000 tools allow you to design graphical applications and then simply compile them to run in a Windows, Macintosh, Motif, or character-based mode. This flexibility allows standardized applications to be deployed across a heterogeneous network of different machines.

Third-Party Tools

Third-party tools you can use to facilitate application development include products such as PowerBuilder from PowerSoft, SQLWindows from Gupta, and Delphi from Borland. Each of these tools is very good and can help speed the development of graphical applications in a Windows or Macintosh environment. These tools are all graphical in nature and allow you to build applications from a graphical console in a drag-and-drop fashion.

PowerBuilder from PowerSoft

PowerBuilder from PowerSoft is by far one of the most popular application development tools. PowerSoft was among the first to introduce these types of products. PowerBuilder comes with ODBC drivers and native drivers that allow you to connect to SQL*Net directly. Using PowerBuilder, you can very quickly prototype and test various applications.

SQLWindows from Gupta

Gupta’s SQLWindows is another very popular application development tool. SQLWindows uses a wizard called QuickForms to help in the development process. Using this tool, you can easily and quickly develop a usable application. SQLWindows comes with ODBC drivers and recommends using them as the primary method of connection. The SQLWindows forms tool is very easy to use and can quickly have you building and running applications.

Delphi from Borland

Delphi is a graphical, drag-and-drop tool that is very easy to use and very powerful. Delphi comes with ODBC drivers and an optional SQL*Net driver. Delphi consists of two main components: the forms developer is simply called Delphi; the reports developer is called ReportSmith.

These tools are very easy to learn; you can be up and building applications in just a few hours. These tools connect to your database and extract the data types directly from Oracle without requiring manual insertion of these values. If you have to deploy applications in a short time frame, I recommend that you use these tools. More detailed descriptions of these tools and ideas for more efficiently tuning the resulting application are given in Chapter 35, “GUI Builders.”


Previous Table of Contents Next


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited.